just a quickie

[Hannah]

can you have a macro that inserts code????

 

[voodoo]

not sure I understand you. Can you explain exactly what you mean by this?

I suppose you could open up a etxt editor and write code to it but not sure why you would want to do it.

 

[Hannah]

don't worry about it...too late in the day for me to be able to find the words to explain what i want to do

 

[Ivan F Moala]

On 2002-08-29 22:31, Hannah wrote:
can you have a macro that inserts code????

Yes you can, what code are you looking to change or amend ?

 

[Hannah]

I want to be able to automatically insert a new page that is similar to exisiting pages (same format but they are for a number of different consultants) and all the same functionalities, and i want to be able to do this by just asking a few inputs from the user and have the results entered into exisiting macros or creating new ones where necessary....is this possible???

 

[PaddyD]

On 2002-09-02 16:53, Hannah wrote:
I want to be able to automatically insert a new page that is similar to exisiting pages (same format but they are for a number of different consultants) and all the same functionalities, and i want to be able to do this by just asking a few inputs from the user and have the results entered into exisiting macros or creating new ones where necessary....is this possible???

Hi Hannah,

In the end. most things are possible! But, to make any progress on this, I think you're going to have to provide more info about the contents of the sheet, what the user inputs are etc.

How about posting back with info about the macros you want coppied, any buttons or other controls there are on the sheet, what the users will be entering etc...

Paddy