Hi.
Sorry for long story... and rally english
I try to create next one.
When opening Excel file and if macros are disabled, user get message " let me run". All anothers worksheets are then very hidden.
If user are enabled macros then he will see several worksheets, exception those what are setted xlsheetveryhidden.
but, before that I read with code environ username and application organization name. That text values will stay on worksheet "environ", cells A2 and A3. From those cells I take with function left result to cells C2 and C3. Wanted results stays in E2 and E3. On cells F2 and F3, I use simple if function to check if answers are similar as I wanted. If not then F5 have 0.
So far it is easy. But when worksheet environ cell F5 are zero I want to delete all worksheets on that file. I have tried many different codes but my skills seems to be too poor.
All those I want to run without any display alerts and without screenupdate flasing. And run those from Private sub workbook open.
Later on when its work it will be saved as template.
was this too long question??
Sorry for long story... and rally english
I try to create next one.
When opening Excel file and if macros are disabled, user get message " let me run". All anothers worksheets are then very hidden.
If user are enabled macros then he will see several worksheets, exception those what are setted xlsheetveryhidden.
but, before that I read with code environ username and application organization name. That text values will stay on worksheet "environ", cells A2 and A3. From those cells I take with function left result to cells C2 and C3. Wanted results stays in E2 and E3. On cells F2 and F3, I use simple if function to check if answers are similar as I wanted. If not then F5 have 0.
So far it is easy. But when worksheet environ cell F5 are zero I want to delete all worksheets on that file. I have tried many different codes but my skills seems to be too poor.
All those I want to run without any display alerts and without screenupdate flasing. And run those from Private sub workbook open.
Later on when its work it will be saved as template.
was this too long question??