momentumons
Board Regular
- Joined
- Mar 30, 2020
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
Hello! I have a document that has some internal-only info but most of it is what we need to send to external parties. I'd love some help creating a macro for my internal doc that will create an "external copy" that:
- is 'paste as values' (ie same formatting but no formulas)
- has a few columns deleted
- headline changed
- macro buttons deleted
The macro needs to work no mater what content is in the sheet - the template will be used every week and will have different number of row and different formatting in those rows. Columns won't change.
It needs to be robust as it ill be used by several different team members.
Thanks!
FYI - I tired to use the "record macro function" to 1. create a copy of the tab; 2. copy & paste as values; 3. delete the required rows/buttons and make the headline change; 4. Move to a new workbook..... but it did not work. It creates the copy but get "runtime error 1004: the item with the specified name wasn't found". In the debugger it looks like a problem with deleting the maco buttons...but this is where I get lost and seek your wise help! I am guessing that is the first of a few problems I will run into on this one
- is 'paste as values' (ie same formatting but no formulas)
- has a few columns deleted
- headline changed
- macro buttons deleted
The macro needs to work no mater what content is in the sheet - the template will be used every week and will have different number of row and different formatting in those rows. Columns won't change.
It needs to be robust as it ill be used by several different team members.
Thanks!
FYI - I tired to use the "record macro function" to 1. create a copy of the tab; 2. copy & paste as values; 3. delete the required rows/buttons and make the headline change; 4. Move to a new workbook..... but it did not work. It creates the copy but get "runtime error 1004: the item with the specified name wasn't found". In the debugger it looks like a problem with deleting the maco buttons...but this is where I get lost and seek your wise help! I am guessing that is the first of a few problems I will run into on this one