Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook with a Master sheet. The Master sheet is visible, but
protected. On the Master are buttons (from the Control Toolbox) that add new sheets and then format them according to 'pages' stored on the Master. So far all code is behind the Master. There is also one form. When new sheets are added, there are new buttons (from the Forms toolbar) on those new sheets; again the code to do is behind the Master. As I understand it, the buttons should be assigned to subs in a general module. I wish to avoid a module if possible. Once the user has completed their workbook, I would like them to be able to: delete buttons in all sheets delete the form delete the Master sheet and save the workbook without any residual code. Can this be done, or must I set a reference to the VBA Extensibilty library (for every user) and use (eg) an external button to remove the code? Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
Wherre best to place code | New Users to Excel | |||
Place space in postal code | Excel Programming | |||
Place code in a new workbook with a macro. | Excel Programming |