Worksheet Protection Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am running Excel 2003.
I have a button(taken from the forms list ) in a worksheet with a macro
attached to it ; that allows users to clear down certain cells in the w/sheet
each time they want to use it. The problem is that when I protect the
w/sheet the button is unavailablee to the users. Because there are quite a
few LOOKUP functions in the W/sheet I cannot afford to let the users have
access to these cells.
All offers of help gratefully accepted
 
You need to post in an Excel newsgroup. This is FrontPage.
--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
: Hello,
: I am running Excel 2003.
: I have a button(taken from the forms list ) in a worksheet with a macro
: attached to it ; that allows users to clear down certain cells in the
w/sheet
: each time they want to use it. The problem is that when I protect the
: w/sheet the button is unavailablee to the users. Because there are quite
a
: few LOOKUP functions in the W/sheet I cannot afford to let the users have
: access to these cells.
: All offers of help gratefully accepted
:
 
Back
Top