Greetings
I currently have a sheet where u click a button, it makes a copy of the sheet and then deletes certain object.
For arguments sake, lets say the one rectangle is "Object 5" and then it gets deleted.
Here is where the problem lies:
It works fine on my computer but as soon as i copy it over to another computer and run it from there, i get a debug error stating "cannot find object" and then it references to the object in the macro code, and the object renamed itself e.g. "object 22" and then it cant delete it.
I have absolutely no clue why the moment when it is copied to another computer why this happens...
Any help will be appreciated.
Bookmarks