Macro to prompt user for name

[olazabal]

I have an accounting workbook and I would like it prompt the user who opens it to enter their name (to create a log of who uses it). I've only found examples that use the user's name to prompt another macro to run, but that's not what I want. I simply want it to store whatever name they enter in a cell on a worksheet. Thanks in advance

[rylo]

Hi

Why prompt for the name when you can use a workbooks_open event to capture either the username or environment username (if they are different) and automatically store it?

Please Login or Register  to view this content.

rylo

[writeguy37]

Could workbooks_open be used to "require" a user to enter information based upon the value placed in a cell? I'm working on an evaluation program, and when a trainer scores someone with an unacceptable score, the trainer needs to provide comments to justify the low score. I'd like excel to "require" that automatically based on the score.

[olazabal]

Hi

Why prompt for the name when you can use a workbooks_open event to capture either the username or environment username (if they are different) and automatically store it?

Please Login or Register  to view this content.

rylo

thanks for the reply. I should have mentioned I'm still pretty new to macros. If I already have an "auto open" macro can I just add your code to that macro? or is workbook _open different than auto_open? Do I have to edit your code in anyway to make it work on my workbook?

[rylo]

Hi

You should be able to just add my code to any existing auto_open macro you have. Now having said that, just watch something go wrong!

rylo

[olazabal]

Not sure what I'm doing wrong, but I can't get it to work. This is what I'm doing:
record macro-->edit macro-->paste the code from above-->stop recording-->save-->run macro

It gives me an error if I leave in the workbook_open part, so here is the code I'm trying to use

Please Login or Register  to view this content.

any ideas on why it won't work?

I can't put my workbook in this thread but I'll PM it to anybody if they think they can figure it out.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[rylo]

Hi

You only need to add the actual code, not the sub / end sub components. I thought you were going to add them to an existing auto_open macro? This just seems to be added to a new one.

Put up an example workbook with the code in it so we can see what you are doing.

rylo