Workbook_open event

[lasher18]

Hi,

I am trying to set up a workbook_open event which will be only running the first time you open the file. In this way, if the macro found a sheet called "LogDetails" the macro will not be executed, else, will create the "LogDetails" sheet.

Please Login or Register  to view this content.

BUT IT IS NOT WORKING AND THAT IS WHY I ASK FOR HELP PLEASE

THANKS A LOT

[Keebellah]

Hi, something like this:

Please Login or Register  to view this content.

[lasher18]

Looks good but it returns me "End If without block if"

[Keebellah]

You forgot your programming skills,?

[Keebellah]

I've checked but, as far as I can see now, there is NO error here. Don't have Excel at hand now, but you can check

[Fluff13]

How about

Please Login or Register  to view this content.

[Keebellah]

Hi, you beat me to it. minor suggestions changes;

Please Login or Register  to view this content.

[lasher18]

Thanks that worked! Now how can I set up a password to enable the view of LogDetails? The thing is that I cannot protect the sheet "LogDetails" with the conventional method because it is registering data from the main sheet (Tracking changes) and if I protect it the macro won't run.

I tried with the following, but it seem it is not right:

Please Login or Register  to view this content.

[Keebellah]

You need to protect that worksheet every time the workbook opens with the parameter USerinterfaceOnly:=True, in this manner a macro can always make changes without needing to unprotect it.
Try this code:

Please Login or Register  to view this content.

[lasher18]

Thank you! Did not know about that property.. As always very helpful

Regards,

[Keebellah]

I think I mentioned it in one of your previous posts, but you can read about if you Google the term