I recieved some great assistance on a project I'm working on just recently,
and I'm 99% done.
As I do a backup of each day, I insert the date into the File.Name so that
others in the office can access it and do their respective thing with the
information enclosed the following day.
What they don't need to see, or have access to is the code attached to it,
both in "ThisWorkbook" & "Modules".
I read a thread a while ago that explained how to do it, but I didn't think
it important at the time so I dismissed it...Go Figure...!
Attached to [ALT-F11] - ThisWorkbook is 2 Subs:
Start_Timer() & Stop_Timer() + there is 7 Modules also attached with a
variety of Subs & Functions
Ideally, I would like for all of it to disappear, though I would still be
happy if it was just the Sub Start_Timer() code that is removed as it is
triggered when the Workbook opens, this represents a major inconvenience and
annoyance to those who do not require it, or know how & where to switch the
So something like:
Selection.Delete, "AllModules", Save = vbNo
Application.Compile, Save = vbYes
Lastly, is it possible to insert something like the following to clean up
the sheet just prior to closing
' This section contains CmdBtns that will be rendered useless and require
removal leaving only a Header Row.