Hi All,
I'm familiar with Excel but new to VBA. I'm trying to add a shape to my worksheet and associate a VBA function that will print the active sheet. I've used the following code from another website:
The code works when I run the macro from the developer menu or when I create a form control. However, when I try to associate this code (written as a module) to a shape (that I want to use as a button), I get the error message "Reference isn't valid". I'm sure there is a very basic tweak I have to make but I'm just beginning with VBA and I dont know what to change so your help would be much appreciated.
Thank you all for your help
Bookmarks