Assign macro to whole page

[swaink]

Hi Everyone

One question is it possible to set up a worksheet, so that if a user clicks anywhere on the sheet it activates a macro.

I'm looking to have a sheet the user can view only and print it off if they wish.

Best regards

Kevin

 

[Derek]

Hi Kevin

Try something like this event macro

Right click sheet tab, left click View Code and paste this code into the white area.
Change "name of your macro" to the one you want to run (retain the quote marks)


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Answer = InputBox("Do you want to print this page? Type YES OR NO")
If Answer = "YES" Then Application.Run "name of your macro"
End Sub

Regards
Derek

 

[swaink]

Cheers Derek

That works a treat

Many thanks