hiding excel button for web page

E

eclark62

Joined
Jun 19, 2006
Messages
4
Reaction score
0
I have created a excel button/macro that saves my worksheet as a web page and then again as my excel worksheet and then closes out excel. I would like to be able to hide the button for viewing the web page but have it appear in the workbook format. Any suggestions?
 
Z

Zoddy

Joined
Jun 14, 2006
Messages
27
Reaction score
0
Hide button

Hi eclark62

add this line of code to the section just before the 'save as' *.htm

ActiveWorkbook.DisplayDrawingObjects = xlHide

then just after the 'save as' add

ActiveWorkbook.DisplayDrawingObjects = xlAll

Regards

Zoddy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a file from a web page 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Is NETWORKDAYS Supported in Excel to Web Page? 5
Access Automatically Send a notification email once a record is added 0
Open Specific Worksheet Using Button Form Control in Excel 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Runtime Error 1004 1
Excel Protection 2

Top