require password each time a macro is executed

[Guest]

Workbook contains serveral worksheets with a number of macros. If the wrong
macro is executed for a given worksheet it will ruin the integrity of the
worksheet.
How do I avoid this problem other than using passwords.

 

[Ivan F Moala]

Workbook contains serveral worksheets with a number of macros. If th
wrong
macro is executed for a given worksheet it will ruin the integrity o
the
worksheet.
How do I avoid this problem other than using passwords.

Hi Marty
If you know which macro should by run in which sheet, then code it s
it checks the sheet before running. Post back if you requir
help.........in coding this ... but give details

 

[bigwheel]

Include a line in your code which checks that the required worksheet is
selected before the macro continues.

 

[Guest]

Thanks Ivan,
I understand but is this an if statement and how do you write it?
Marty

 

[Guest]

Thanks Bigwheel,
I am rather new at this and understand your answere but have no idea how to
write it . Can you help?
Thanks again
Marty

 

[Dave Peterson]

If you can pick out something unique for that type of worksheet, then you can
test that to see if it's there.

For instance, if you have headers in A1:X1 and A1 always contains the text:
"Order Number"

you could put this at the top of your code:

sub testme()
if activesheet.range("a1").value <> "Order Number" then
msgbox "Not on this sheet"
exit sub
end if
'your other code here
end sub

The question now becomes: Can you find something unique?

 

[Tom Ogilvy]

Sub Macro1()

if lcase(Activesheet.Name) <> "sheet1" then
msgbox "Sheet2 must be active to run this macro"
exit sub
End if

' existing code that works on the active sheet.

End Sub

Thanks Ivan,
I understand but is this an if statement and how do you write it?
Marty