Hi everyone,
I am pretty new to excel and am trying to auto update several existing spreadsheets using one update button in a seperate file. I do not have access to the coding of some of the sheets and when they update they need an 'ok' pop up to be clicked before i can close and save them.
I am using "ActiveSheet.CommandButtonupdate_Click" to start the update in each sheet but it always fails when the pop up occurs.
If any one has a way around it i would be grateful.
Thanks,
Paul.
I am pretty new to excel and am trying to auto update several existing spreadsheets using one update button in a seperate file. I do not have access to the coding of some of the sheets and when they update they need an 'ok' pop up to be clicked before i can close and save them.
I am using "ActiveSheet.CommandButtonupdate_Click" to start the update in each sheet but it always fails when the pop up occurs.
If any one has a way around it i would be grateful.
Thanks,
Paul.