Editing Code from Code

[Barkingmadscot]

I have addin i load automatically and start in code, but i only want to
load the addins a some execl sheet on all, The reason i can have the
addin loading all the time is the addins is licence based and has
licence server.

I want to add code into the each execl sheet that requires the addin to
be loaded.

Private Sub Workbook_Open()

Run ("MyAdd")

End Sub

We have hunderds of excel sheets and about small fraction requires this
add. Can i copy the lines of code about to the start of execl sheets.
The users that use this addin also open execl and dont require the
addins and i dont what them using the addin.

At the moment i have a message asking each time a excel sheet loaded
(when that addin is enable) if the addin is to be loaded.

What i want to do is ask the user if the addin is required then copy
the lines of codes to currently opened workbook and never asked again.
I know i will have some work. Just need help on how to copy/write
lines of codes from the addin to the worksheet, that if it is possible

 

[Niek Otten]

Try this:

http://www.cpearson.com/excel/vbe.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have addin i load automatically and start in code, but i only want to
| load the addins a some execl sheet on all, The reason i can have the
| addin loading all the time is the addins is licence based and has
| licence server.
|
| I want to add code into the each execl sheet that requires the addin to
| be loaded.
|
| Private Sub Workbook_Open()
|
| Run ("MyAdd")
|
| End Sub
|
| We have hunderds of excel sheets and about small fraction requires this
| add. Can i copy the lines of code about to the start of execl sheets.
| The users that use this addin also open execl and dont require the
| addins and i dont what them using the addin.
|
| At the moment i have a message asking each time a excel sheet loaded
| (when that addin is enable) if the addin is to be loaded.
|
| What i want to do is ask the user if the addin is required then copy
| the lines of codes to currently opened workbook and never asked again.
| I know i will have some work. Just need help on how to copy/write
| lines of codes from the addin to the worksheet, that if it is possible
|