Pauseing and resuming a macro for user input

[themarchs]

This is a three-part question, but I think they are similar
I have created a school report card and have a main menu area for the teachers where they can choose what they need to do. A few problems I have are:

I need a macro or VBA that will allow a user to go to save as and give a read only file a new name and location then return to the sheet.

I also need another macro or VBA to do something similar except it is to open a new or existing file.

I need a way to let users get to another sheet and enter some information then return to the main menu.

I have removed all menus and tab sheets so as to make it very hard for the users to make any errors in their input. Sheet protection is also turned on.

I think what I need is a way for the macro or VBA to pause then resume after some input.

Thank you in advance to any and all help

 

[Chattin]

This any use to you for part of your problem?

http://j-walk.com/ss/excel/tips/tip81.htm

HTH