Importing .BAS to Sheet Object... NOT Class Module?

Hi Guys,

Been trawling though all the posts and appear to have found something that hasn't already been answered (long shot I know!).

Here's my full code:

Please Login or Register  to view this content.

I am copying a load of filtered data to separate worksheets for use by different sales people... They're bound to try and break things, so their final files have protection enabled... They need to be able to insert extra rows of data, so I have built a macro that unprotects and copies various formulas to the inserted row when it detects a row is inserted. Here's the code for the macro I wish to insert into the sheet object:

Please Login or Register  to view this content.

You can see in the "copy sheet macro" of my first code that I am copying the macro from Sheet6... I then want to paste it into Sheet1 of the new workbook:

Please Login or Register  to view this content.

Unfortunately, this creates a class module which means it doesn't activate when a row is inserted on Sheet1. When I try and define the VBComponents as Sheet1 the macro breaks stating "Object doesn't support this property or method".

Thanks for any help you guys can give!!!

crabby

So, it's really that hard? I'll change my code to use a template, but would love to understand why it's so easy to export from any object but so hard to import?

Thanks,

crabby

Well.. That's me learnt!

I simply produced a blank sheet in my master document with the macro embedded and changed my formula to this:

Please Login or Register  to view this content.

Thanks,

crabby