Earlier I asked what the best way to clone a spreadsheet was and was told to use a Class module.
I've eventually come up with the following which appears to work quite well. If this is the wrong approach could you please let me know:
Create a class module clsGutter:
In a standard module I have a public object:
And during the Workbook_Open event I call the following procedure:
This all works fine with the application events being trapped by the new class, so as each new worksheet is added to the work book they behave in an identical way with all the events in place and being called.
However, even though I have declared the properties of the class as public, the macros complain that they do not exist:
This code causes a run time error 438 - "object doesn't support this property or method" even though the Gutter class is active and the property get has been declared as public.
Where am I going wrong ??
Cheers,
Rich
Bookmarks