Is there a VBA code which returns to the previous sheet??

[zilch4ry]

Hi,

I have created a macro which finishes the time spent on a specific worksheet by cutting information entered into cells and places them on a different worksheet (the worksheet is only used to create a new account). This "New Member" worksheet can be found by using either of two macros- one located on the "Home" worksheet and one located on the "Order" worksheet.

My question is, is that once the user has hit finish I don't know where to relocate them back to, because they can enter this worksheet from two completely different worksheets.

Is there a code which sends the user back to the page they were on originally?


If that made any sense to anybody, help would be greatly appreciated


Thanks,



Tom

 

[Juan Pablo González]

You need to store the original worksheet at the top of the macro.

Dim origWS As Worksheet

Set origWS = ActiveSheet

'Your code

origWS.Activate

 

[zilch4ry]

I might have got this wrong, but there are two worksheets that the user can choose from- does this only allow me to select one worksheet the user can return to?

 

[Norie]

How does the focus end up on a different worksheet from where it was initiated?

It might be possible to prevent that happening and still get things done.

ie do what you want without activating another worksheet

 

[zilch4ry]

This might be a little confusing but this is what ive done:

I was told to produce an pizza ordering spreadsheet for ICT

One of the specifications for spreadsheet was to keep a customer database

To create the customer database i have another worksheet where a customer can enter their details and then click a "Finish" macro button- this cuts all cells and pastes the information into the next free row on the customer database worksheet

To get to the worksheet where users enter there details ("New Member" worksheet) i have two ways- one way it to get there using a macro button found on the "Order" worksheet and another way which is on the "Home" worksheet.

The problem i am having is that when the customer clicks the "Finish" macro on the "New member" worksheet i don't know where to relocate them, because they can come from either one of the two worksheets.

So is there a way to just say go back to the worksheet they were on, before they were relocated to the "New Member" worksheet.


is this even possible?