Command Button Limits 1

[Guest_imported]

How do I limit the use of a command button to a specific worksheet/worksheets, with a popup message for effect?

 

[xlbo]

More info please - what do you want to limit??
Where is the button located ??
HTH
~Geoff~

 

[Guest_imported]

It's on a userform in a Workbook Template. I want the command to work on certain sheets only. The trouble is other users have use of the workbook and will misuse the command, so i need to limit its use.

 

[xlbo]

If your sheetnames are standard, then just use an if statement to preclude the use on the sheets you don't want
eg
mSheet = activesheet.name
Select Case mSheet
case "Sheet1","Sheet2","Sheet3"
--do stuff
case else
msgbox "You can't use that command on sheet " & msheet
end select
HTH
~Geoff~

 

[Guest_imported]

Cheers,

You are the man!!!!!