|
-
Apr 15th, 2009, 03:34 AM
#1
Thread Starter
Addicted Member
Disable Excel Prompts
How can I disable All prompts in Excel when a workbook opens?
For example if a user is in a Workbook and I then open same Workbook the prompt saying ReadOnly, Notify, Cancel appears. How can I get rid of that?
-
Apr 15th, 2009, 03:45 AM
#2
Re: Disable Excel Prompts
To disable prompts in Excel via VBA you can use
Application.DisplayAlerts = False
However there are some prompts that you cannot disable (I believe and I could be wrong).
This is a basic Alert which I believe cannot be disabled. And why would you want to to that?
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread " Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Apr 15th, 2009, 04:45 AM
#3
Thread Starter
Addicted Member
Re: Disable Excel Prompts
I was wanting to disable that so that I can create my own LogIn for a Workbook, I wanted to choose who was a ReadOnly user or not as posted in this thread below.
http://www.excelforum.com/excel-prog...use-excel.html
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
