Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Button When Worksheet is Locked
I have a macro that emails the first page of a worksheet from http://www.rondebruin.nl/mail/folder3/mail4.htm However, this macro doesn't work if the worksheet is locked. I was wondering if there is a way for me to make some sort of a button visual cue (i.e. grayed out) or an error message box to let the user know he needs to unlocked the worksheet first. Or on another note, maybe a pie in the sky request, to include within the macro a code to unlocked worsheet first then lock it back again when email has been sent. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Enable or Disable Forms Button on a worksheet from code | Excel Programming | |||
code to disable "this cell contains a formula is not locked" warni | Excel Programming | |||
Disable the Close Window button of the worksheet | Excel Programming | |||
need code for disable selection of locked cells | Excel Programming |