Where to place Code question
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.
|