Discussion on:

Message 4 of 65
0 Votes
+ -
Has to be in a module
PUBLIC TYPE can only work at the module level. In the VBA editor, in the project window, right-click on the spreadsheet and insert a module, then copy the code into the module.
Posted by DelbertPGH
3rd Nov 2010