scripting in excel (vb)

M

Mike

I am scripting excel into a personalized data entry setup.
I have a main database window and then seperate record view windows.
Problem is.
If I prevent the record view from closing (cancel=true) in the
beforeClose sub and the activate the main window (database view) again
the clicking is off. I click a cell and a cell 1 space to the right
gets highlighted. If I let the record window close then it is fine.

ALSO:
If I let the window close I get a pop up asking if I want to save it.
Is there a way to supress this? I don't want anything but the main
database window asking to save changes.

Thanks
Mike Parks

Afraid this is an older excel version (97), but your solution may
still work so please reply....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I freeze the swimlane headers? 0
Dynamic Naming of Form Button 3
Merging from an Excel file with graphics 1
Set as Default Template not working 0
Autonumber field in Excel that behaves the same as Access 0
Improving Macro That Keeps First Letter 0
Dealing with the error: unable to filter on excel hc home school 0
Making a macro only work on certain files 2

Top