Stonecold300
New Member
- Joined
- Mar 20, 2018
- Messages
- 1
Hi.
My colleagues are not good with excel, and sadly I am their last hope. I have created spreadsheets that measure the profitability of jobs, and need to lock cells and protect them. I then need to automate the formatting so they cant unlock the sheet by themselves (the macro does it for them , makes the changes and relocks the sheet afterwards). This way they can't break the formulas. This includes hiding rows and columns and then unhiding them again as needed. I can do some of that but the main issue a printing one: I want to print columns A:G as standard and them automatically print the 7 columns next to those, that relate only to the week in review. That could mean hiding week 1 (with 7 columns) to print week 2, and also hiding week 3-26 so that only week 2 appears on the page next to columns A:G. How do I do this with one click?
Thanks
My colleagues are not good with excel, and sadly I am their last hope. I have created spreadsheets that measure the profitability of jobs, and need to lock cells and protect them. I then need to automate the formatting so they cant unlock the sheet by themselves (the macro does it for them , makes the changes and relocks the sheet afterwards). This way they can't break the formulas. This includes hiding rows and columns and then unhiding them again as needed. I can do some of that but the main issue a printing one: I want to print columns A:G as standard and them automatically print the 7 columns next to those, that relate only to the week in review. That could mean hiding week 1 (with 7 columns) to print week 2, and also hiding week 3-26 so that only week 2 appears on the page next to columns A:G. How do I do this with one click?
Thanks