LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Protecting buttons with VB code rather than protecting sheets/books?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
protecting formulas without protecting sheet so grouping still wor JM Excel Discussion (Misc queries) 1 June 4th 09 06:42 AM
protecting all but command buttons Monish Excel Discussion (Misc queries) 0 August 6th 07 03:52 PM
Vital: Protecting sheets so macros/buttons still work? StargateFanFromWork Excel Programming 13 July 5th 04 09:23 PM
Protecting VBA Code steve Excel Programming 0 August 28th 03 09:13 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"