Thread
:
Why are the protection settings disappearing when I run my macro?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Why are the protection settings disappearing when I run my macro?
It might be nice to see the macro?
--
Don Guillett
SalesAid Software
"Stephanie" wrote in message
...
Hi. I've created several macros for my spreadsheet, which, with the help
of
some of you, are running wonderfully! My problem is that my spreadsheet
will
be used by multiple people and I need to protect them from themselves. I
have protected the worksheet and checked the boxes to allow them to format
only the unlocked cells. The problem is that after the macro(s) runs, the
boxes I checked when I protected the spreadsheet are no longer checked.
I'm
not sure why this is happening and what I can do to stop it from
happening?
Just in case you need to know... I'm using Excel 2003.
Any suggestions?
Thanks!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett