Automatically runing a macro
Dave Peterson wrote in :
right click on the excel icon to the left of the File|Edit|View|...
menubar.
Select view code and paste it in that right hand window.
Your macro code should continue to live in a General module.
Peter Longstaff wrote:
"Tom Ogilvy" wrote in news:OtNqSOPaDHA.2632
@TK2MSFTNGP09.phx.gbl:
Private sub Workbook_Open()
if thisworkbook.Path = "" then
mymacro
End if
End Sub
Hi Tom,
thanks for this but i do not know where to place this function. DO I
place it in the workbook or the specific sheet ?
TIA
Peter
Thanks everyone, that has sorted it.
I owe you all one.
Peter
|