Return User To Cell After Macro has Run

Re: Address and GoTo and Timing

Hi, For your timing answer try this link http://www.ozgrid.com/forum/showthread.php?t=57009 , and as for your which sheet/cell try

Set ActSht = ActiveSheet
Set ActCell = ActiveCell

I have also used this in my coding so i can get back to the sheet i left

Dim OriginalSheet
OriginalSheet = ActiveSheet.Name

Im no expert or even that experienced but i think if you set a variable to them you can call on that variable.....wow i even sounded like i know what im talking about! maybe it will help maybe not!

Regards,
Simon

Re: Address and GoTo and Timing

There shouldn't be a need for the sheet or cell to change in VBA code. However, try this. Note you only need the cell Set to a Range Variable

Sub BackToStar()
Dim rStartCell As Range


Set rStartCell = ActiveCell
'Your code
Application.Goto rStartCell


End Sub

Re: Address and GoTo and Timing

For your running macros at set times, see
How to Run a Macro at a Set Time

In future, please don't ask question in a Thread that do NOT match the Thread Title. The rules you agreed to state this and I would appreciate it if you took the time to read them, then adhere to them.

Re: Return User To Cell After Macro has Run

Your idea might well have one fundamental flaw - your code won't run if the user disables macros. I personally, would be extremely annoyed if I was woirking on a spreadsheet, & without my control, the code took over.