Protecting a sheet (yet allowing buttons/macros to work)?

B

Bridget

I'm new to the button/macro feature of Excel (even though
I've been assigning macros to _toolbars_ for years <g>!)
So, I don't even know if what I need to do can be done:

Ideally, it would be nice if I could protect all the
sheets or even better the workbook in one fell swoop, so
that no-one could accidentally delete the buttons YET that
would still allow the macros to work.

I've tried everything I know and the best I seem to be
able to do, yes, protects the buttons but I the macros
stop working and display a ""Run-time error '1004'". This
protection, then, is defeating the macros which is no good
(obviously! <lol>)

Pls, what am I doing wrong? Can we protect a workbook so
that all the button/macro elements are safe yet they still
work? If so, how would one do that?

Thank you so much!
 
S

StargateFan

I'm new to the button/macro feature of Excel (even though
I've been assigning macros to _toolbars_ for years <g>!)
So, I don't even know if what I need to do can be done:

Ideally, it would be nice if I could protect all the
sheets or even better the workbook in one fell swoop, so
that no-one could accidentally delete the buttons YET that
would still allow the macros to work.

I've tried everything I know and the best I seem to be
able to do, yes, protects the buttons but I the macros
stop working and display a ""Run-time error '1004'". This
protection, then, is defeating the macros which is no good
(obviously! <lol>)

Pls, what am I doing wrong? Can we protect a workbook so
that all the button/macro elements are safe yet they still
work? If so, how would one do that?

Thank you so much!
Click to expand...

Hi, me writing from home! (Boy do I miss Agent at work! <lol>!)

Can anyone tell me if it's possible.

I also wanted to reassure everyone that I figure out a _lot_ of things
on my own. I go to the help first then to the net. It's when I don't
find anything that I come here.

And this is a problem I did research a bit more than others but I
didn't come up with anything relevant on how to protect the sheet (so
users can't accidentally delete the buttons!) yet still allows the
buttons to work!

Thanks!
 
Top