I'm trying to write a macro which automates the sheet numbers on my drawings. For example sheet 2 of 3.
I have found a code which works to print this information in the sheet background although I cannot find a way to update these numbers if a sheet is later added or deleted. At the moment if I run the macro again it simply prints the new numbers on top of the previous (so you can see both).
I'm trying to find a way that the existing text box can be either updated or deleted by the macro when an update is needed.
Hope this makes sense! Any help would be greatly appreciated.
I have found a code which works to print this information in the sheet background although I cannot find a way to update these numbers if a sheet is later added or deleted. At the moment if I run the macro again it simply prints the new numbers on top of the previous (so you can see both).
I'm trying to find a way that the existing text box can be either updated or deleted by the macro when an update is needed.
Hope this makes sense! Any help would be greatly appreciated.