Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros execution problem
HI,
all I am trying to insert columns using macros. Sheet1.select Columns(G:G).select Activecell.Insert I am trying to insert few more columns. This is done at workbook_open time. Inserting of columns is happening in the sheet after some data is already loaded. But each time I am opening the workbook .It again inserts the new row. Is there a way I can stop this after it has been executed once and filled with data then when the person reopens the sheet it should directly open the sheet without asking for enable macros or disable macros. The above sheet is downloaded from the server via webpage and then saved into individuals computer.After that they need to reopen the sheet to see the data. That's why it's causing problem. Any small help in this regard would be highly appreciated. I am in real need for my project. -- Kittie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Macros | Excel Discussion (Misc queries) | |||
Macros Problem | Excel Discussion (Misc queries) | |||
Macros - Force execution using workbook_open | Excel Discussion (Misc queries) | |||
Problem with 'For' loop execution [VBA,Excel XP] | Excel Programming | |||
Problem with macros on Mac | Excel Programming |