Using Global variable in module

Hello,

I have a workbook that I am using to track costs throughout a project. This is used by multiple people and is normally protected once an initial cost estimate is determined. I have added an "Insert Revision" button that will allow a user to add a revision without overwriting any of the existing data. When inserting any revision they are prompted to enter their initials into an input box. I am wanting to prompt the user to enter their initials when they first open the workbook so they do not have to enter it for every revision they do. Once they enter their initials they would be used in the InsertRevision module and in the Workbook BeforeSave automatically generated email. I was trying to set this up with the Workbook_Open() macro. Is this the right way to go about it or do I need to do this with its own module?

Thank you!

Arkadi,

Thank you for the quick reply. I made the changes you suggested and was able to get the input box to pop up correctly when the document opens. I am trying to use the Enterinitials value in the below module but when I run InsertRevision it only shows the date in the column G. What do I need to do to get it to read Enterinitials from the workbook?

Please Login or Register  to view this content.

I am still not getting the initials to show up in column G when running the Insert Revision sub. I have tried changing Workbook_Open to a Public sub and that did not make any difference. I have attached the updated Test file as well.

This the code for when the workbook opens

Please Login or Register  to view this content.

This is what I have for the Insert_Revision Sub

Please Login or Register  to view this content.

That worked! Thank you Arkadi.