Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a Macro on exel be set with a password?
I would like a macro button to be password protected on a spread sheet that I
have, so people can look a things on the other sheets, but not on one of them. Thanks Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a Macro on exel be set with a password?
if you need to protect worksheet try next:
activate sheet - Format-Sheet-Hide Tools-Protection-Protect Worksheet "Dave" wrote in message ... I would like a macro button to be password protected on a spread sheet that I have, so people can look a things on the other sheets, but not on one of them. Thanks Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a Macro on exel be set with a password?
Dave
What do you mean by "macro button to be password protected"? If you don't want anyone to see the sheet, hide the sheet then protect the workbook for windows and structure. If you don't want anyone to run a macro from your button, password protect the code. Sub foo() Dim mypword As String mypword = InputBox("enter a password") If mypword < "drowssap" Then MsgBox "wrong password" Exit Sub Else MsgBox "what now, brown cow" End If End Sub Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 19:00:16 +0200, "Sasa Stankovic" wrote: if you need to protect worksheet try next: activate sheet - Format-Sheet-Hide Tools-Protection-Protect Worksheet "Dave" wrote in message ... I would like a macro button to be password protected on a spread sheet that I have, so people can look a things on the other sheets, but not on one of them. Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to unlock the password for the exel workbook | Excel Discussion (Misc queries) | |||
i forgot the password used for the exel sheet | New Users to Excel | |||
How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
Exel Worksheet Protected With A Password | Excel Worksheet Functions | |||
Password protect folders in Exel | Excel Discussion (Misc queries) |