Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Protection
Hi again, i have a simple macro that clears unlocked cell contents on a worksheet. However, as the worksheet is used by several people its possible one of them may run the macro...unlikely but i'd rather they didn't have the choice. Is it possible to password protect the macro or something similar? Thanks. -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555276 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Protection
Hi Fodman,
If you preface your macro with the word Private, the macro will not show up in the list of macros, e.g.: Private Sub MyMacro 'Your code End sub Alternatvely, try something like: '============= Public Sub MyMacro() Dim res As String res = InputBox("Insert the password") If res < "YourPassword" Then Exit Sub End If 'Your code End Sub '<<============= --- Regards, Norman "fodman" wrote in message ... Hi again, i have a simple macro that clears unlocked cell contents on a worksheet. However, as the worksheet is used by several people its possible one of them may run the macro...unlikely but i'd rather they didn't have the choice. Is it possible to password protect the macro or something similar? Thanks. -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555276 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Protection
Am i missing something?....How then do* i *find the macro if it doessn't show up in the macro list? -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555276 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Protection
Hi Fodman,
Even though the macro will not show up in the macro dialog, you can run the macro by typing the macro's name. However, why not try my suggested password suggestion? --- Regards, Norman "fodman" wrote in message ... Am i missing something?....How then do* i *find the macro if it doessn't show up in the macro list? -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555276 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook Protection Toggle Macro | Excel Discussion (Misc queries) | |||
macro for protection | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |