Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I ran into endless troubles protecting sheets, as some know (also, as I now
feel sure must be a common problem already commonly known). When the sheets were protected, many of the functions of the buttons as well as required general functions would no longer work. We got around a few of the restrictions by having unprotect/protect sheet coding at beginning and end of the macros, but that was a tricky and time-consuming workaround to the problem which still didn't allow simple things like inserting rows, etc., to be done. Again, a lot of time and complex coding would have gotten around that, possibly, but not in the time I had available. So, I've left the sheets "live", as it were. All of them! But I've been mulling things over in my mind. The greatest problem that might not be as easily overcome as other erasures in these sheets, really, is accidental erasure of those buttons. Granted I put copies with the attached macros elsewhere in the sheet, out of sight yet easily accessible. I had originally planned to put them on a hidden sheet but have too many hidden sheets for data validation purposes so putting them out of the print area seems a good alternative. Anyway, I got to thinking, is there a way to "protect" the buttons themselves just from being erased and perhaps even moved using some sort of VB code? Something that would not interfere with their function, just would protect them from being eradicated <g. I know I'm fishing with this one <g, but this doesn't seem like an impossibly overly-ambitious thing <g(?). Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
protecting all but command buttons | Excel Discussion (Misc queries) | |||
Vital: Protecting sheets so macros/buttons still work? | Excel Programming | |||
Protecting VBA Code | Excel Programming |