Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide button from Template
I have a macro linked to a command button on an excel template. I'd like to
have the button hidden (or deleted) on the new spreadsheet the user will save to another name. |
#2
|
|||
|
|||
Not sure when you want the button deleted, but one way to delete it is:
Worksheets("sheet1").OLEObjects("CommandButton1"). Delete Chip Pearson has some instructions on how to remove code (or add code) on the fly. http://www.cpearson.com/excel/vbe.htm Have you thought of removing the code (and button) from your template and using another workbook for the code (maybe even a nice toolbar floating over your workbook). Dennis wrote: I have a macro linked to a command button on an excel template. I'd like to have the button hidden (or deleted) on the new spreadsheet the user will save to another name. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |