File Save as autodirect

**ErinJ** · 05-25-2011, 05:52 PM

I currently l have the following code but I'd like it to work without the command button. How can I make this work by using the save as option

Please Login or Register  to view this content.

**shg** · 05-25-2011, 06:47 PM

Welcome to the forum, Erin.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

I don't understand your question; you are using the SaveAs method.

**ErinJ** · 05-26-2011, 12:17 PM

I don't know if I'm using the code tag right or not but I made the change I think.

What I posted was my code that I attached to a command button. I want to do away with the command button and when someone edits the worksheet and clicks file save as it runs the code.

**shg** · 05-26-2011, 01:09 PM

The closing code tag is [/CODE]

Is everyone saving the file to the same place on a network share, and you're just trying to accommodate different drive mappings?