C
chief
I have a workbook set up and i'm having a tough time with this
protection stuff. I have tried different .unprotect methods but it
doesn't work. I have a print button with coded conditions such as if
cell a1 = "this" then certain cells get the borders formatted to be
white, etc. then it prints one page, changes the format back and then
prints 2 pages like that and saves the page. Anyways, bottom line is
that there are format changes which are done before and after printing.
My code is set up so that as soon as the person goes into the main page,
it becomes protected in order to save formulas in certaing cells, then
when they click this print button the sheet SHOULD unprotect, allow for
these changes and printing to happen and then close. I don't care about
re-protecting the sheet after printing because the code is set up to
close the sheet as soon as it prints. Can anybody please help me, I'm
going nuts. If it makes it easier I can post the codes in a reply.
Thanks
protection stuff. I have tried different .unprotect methods but it
doesn't work. I have a print button with coded conditions such as if
cell a1 = "this" then certain cells get the borders formatted to be
white, etc. then it prints one page, changes the format back and then
prints 2 pages like that and saves the page. Anyways, bottom line is
that there are format changes which are done before and after printing.
My code is set up so that as soon as the person goes into the main page,
it becomes protected in order to save formulas in certaing cells, then
when they click this print button the sheet SHOULD unprotect, allow for
these changes and printing to happen and then close. I don't care about
re-protecting the sheet after printing because the code is set up to
close the sheet as soon as it prints. Can anybody please help me, I'm
going nuts. If it makes it easier I can post the codes in a reply.
Thanks