Hi
I have a process where a user submits a copy of a file AAA.xlsm to a new folder using a macro, where it is saved with the name as AAA Final.xlsm. Following on from this the original file is then saved as read only with password protection.
The original file has 8 worksheets in it some of which are hidden and two contain tables. When I tried to group the sheets to copy them to a new file I was unable to do so as it doesn't appear to be possible to group sheets with tables in them.
It looks like the only way I can do this is to copy each sheet individually into a new workbook and then save that with the new name. The hidden sheets will be veryhidden and I know I will need to unhide them before copying them. I am anticipating that the users will only have permission to write to this folder as there is no need for them to see the new file once it has been saved.
Alternatively is there a way of saving the file and then returning to the original file.
Thanks
StewartS
I have a process where a user submits a copy of a file AAA.xlsm to a new folder using a macro, where it is saved with the name as AAA Final.xlsm. Following on from this the original file is then saved as read only with password protection.
The original file has 8 worksheets in it some of which are hidden and two contain tables. When I tried to group the sheets to copy them to a new file I was unable to do so as it doesn't appear to be possible to group sheets with tables in them.
It looks like the only way I can do this is to copy each sheet individually into a new workbook and then save that with the new name. The hidden sheets will be veryhidden and I know I will need to unhide them before copying them. I am anticipating that the users will only have permission to write to this folder as there is no need for them to see the new file once it has been saved.
Alternatively is there a way of saving the file and then returning to the original file.
Thanks
StewartS