ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SaveAsUI (https://www.excelbanter.com/excel-programming/359672-saveasui.html)

Desert Piranha[_70_]

SaveAsUI
 

Hi all,

Whats the "UI" mean in this:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=535823


Nigel

SaveAsUI
 
From Excel VBA help.......

SaveAsUi True if the Save As dialog box will be displayed.

The UI (user interface), in this case the save as dialog box will or will
not be displayed depending on the value of this parameter.

--
Cheers
Nigel



"Desert Piranha"
<Desert.Piranha.26t2la_1145944200.9682@excelforu m-nospam.com wrote in
message news:Desert.Piranha.26t2la_1145944200.9682@excelfo rum-nospam.com...

Hi all,

Whats the "UI" mean in this:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=535823




Desert Piranha[_71_]

SaveAsUI
 

Nigel Wrote:
From Excel VBA help.......

SaveAsUi True if the Save As dialog box will be displayed.

The UI (user interface), in this case the save as dialog box will or
will
not be displayed depending on the value of this parameter.

--
Cheers
Nigel



"Desert Piranha"
<Desert.Piranha.26t2la_1145944200.9682@excelforu m-nospam.com wrote in
message
news:Desert.Piranha.26t2la_1145944200.9682@excelfo rum-nospam.com...

Hi all,

Whats the "UI" mean in this:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)


--
Desert Piranha



------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread:

http://www.excelforum.com/showthread...hreadid=535823
Hi Nigel,

Thank you for your explanation. I understand now.

Thx again


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=535823



All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com