I've been trying to create a macro which closes excel without the save pop-up coming up, anyone got any ideas? I don't want it to save, this is because i don't want anyone who uses it to muck it up!
grandfilth
0
Newbie Poster
Recommended Answers
Jump to PostWhy not make it read only?
Check the switches section of VBA -
I believe it's the app.close or END command
Jump to Postummm that's not closing Excel. I think what you are trying to do is to create a form. With no tool bars, and limited controls for users.
If that is the case you will need a USERFORM. So that Users only see the information and cannnot modify the Rows/Colums.
…
All 5 Replies
Kegtapper
0
Junior Poster
grandfilth
0
Newbie Poster
Kegtapper
0
Junior Poster
grandfilth
0
Newbie Poster
Comatose
290
Taboo Programmer
Team Colleague
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.