Disable Only Close Button In Excel Workbook?

May 16, 2006

Sample code on disabling the close button in Excel workbook?

I tried the Tool -> Protect -> Check Windows method. But, it will disable the maximize and minimize buttons as well. Moreover, it will minimize the workbook.

View 2 Replies


Excel 2010 :: Disable Default Close Button In Workbook

Jun 3, 2014

How to disable the default close button in a workbook not to affect in my command button close.

I tried already cancel = true but my command button close is also been canceled.

View 3 Replies View Related

How To Disable / Dim Close (X) Button

Oct 4, 2010

Is there anyway to easily disable/dim the Excel Close (X) Button as I want to force my users to close an Excel workbook via a button?

View 9 Replies View Related

Disable User Ability To Close Workbook

Jan 25, 2007

I have a workbook that has a macro that needs to run before it is closed. I have a button on my sheet that runs that macro and then closes the sheet. Is there a way that I can disable the "X" at the top right hand of the workbook and force the user to close the workbook via my button?

View 3 Replies View Related

Compile Error On Close Of Excel 2003 But Not On Close Of Workbook

Mar 22, 2012

I am using Excel 2003.

It’s been working perfectly up until around an hour ago. However, now when I close Excel, I get compile errors.

These compile errors seem to be because Excel is trying to access controls in the workbook after it has closed. Since the workbook is closed, VBA can no longer ‘see’ the controls, and therefore it thows up errors.

I’m also getting a similar error on a Worksheets("DataExplorer").unprotect line, which seems to be because the worksheet isn’t there after closing.

These errors only occur when I close the whole excel application using the big cross in the top right. If I just close the workbook (using the smaller cross just below the big cross in the top right of excel), it doesn’t throw up these errors.

Just to clarify: all of the code runs perfectly when Excel is open. The errors are being thrown up for lines of code which run without problem until Excel is closed.

View 9 Replies View Related

400 Error When Excel Close Button Is Pressed

Jan 10, 2014

Why I receive a 400 error when the 'excel close' button is pressed in the attached sample.

View 2 Replies View Related

Excel 2010 :: Close Second Workbook From Workbook BeforeClose?

May 27, 2014

I cannot make this work in XL2010.

I am opening a second workbook in ReadOnly in the Workbook Open and Closing it in the Workbook BeforeClose.

I don't EVER want to save changes on either workbook.

I need to leave excel open as the macro created a 3rd workbook which the user will need.


View 6 Replies View Related

Excel - Auto Sorting Data After Clicking Close Button On DataForm

Mar 25, 2014

I have a problem on auto-sorting my data after clicking the "x" or "Close" button on DataForm. Im creating a command button that trigger a macro to open an autofill DataForm. I want a code that everytime i ADD or EDIT using the DataForm, it will automatically sort the Column A after clicking the "x" or "Close" button. Below is the code of my macro:

Sub OpenForm()
End Sub

View 1 Replies View Related

Disable Printing In Excel Workbook That Has 3 Worksheets?

Jul 15, 2014

I am trying to disable printing in an Excel workbook that has 3 worksheets. I do want any worksheets to be able to print.

View 2 Replies View Related

Disable Copy / Paste Into Excel Workbook?

Feb 16, 2014

I Have a spreadsheet in which data is spreading into column A-Z. I would like to disable copy, paste, ^V,^R,^C, ^D for certain columns (Q-U) of the workbook so that user is forced to enter data manually on these columns.

Is there any simple of doing this using VBA.

View 2 Replies View Related

Disable Close On Msg And Input Box

Jul 13, 2006

Is it possible to disable the 'X' close button on inputbox and msgbox
or any way of making the 'X' not close the box

View 2 Replies View Related

Disable Form Close

Dec 13, 2006

Is there any easy way to disable the close (X) button at the top right of a form.

I've been trying...

Private Sub UserForm_Terminate()
Unload UserForm2
End Sub

but i get a problem when re-opening the userform2??

View 2 Replies View Related

Disable Close (X) On Specific Worksheet

Jan 9, 2010

I have a pivot table that's made visible from a "Drill Down" button on the source worksheet.

View 4 Replies View Related

Disable The 3 Buttons (minimize / Restore And Close)

Feb 26, 2012

I want to disable the three buttons (minimize, restore and close) excel.


View 14 Replies View Related

Disable Red X But Keep Enable File - Close Working

Dec 24, 2008

I want to hide all toolbars and disable the red X upon opening of the spreadsheet, and to restore the main toolbars upon closing. That worked perfectly. (when I used the black code -see below)
I added in the red code as i wanted to disable the red X as well to ensure that users will always close the EXCEL worksheet via a Macro button.

The Macro will save the spreadsheet and close the worksheet and the Private sub should restore the toolbars.

View 7 Replies View Related

Excel 2007 :: VBA To Save And Close All Open Workbooks Except Macro Workbook?

Mar 8, 2013

I have a macro that opens all workbooks from one directory and runs a macro for each workbook to clean up the data. I cannot figure out how to take all those open workbooks and save them to another directory and close the workbook. Also, I do not want the macro workbook (xlsm) to save. I only want it to close. I am working in 2007 Excel.

View 8 Replies View Related

Disabling "x" To Close & Creating Macro Button To Close

Oct 11, 2006

I need to know the command to close a workbook. I have used the information found here: http://www.ozgrid.com/VBA/userform-close.htm to disable closing the workbook via the upper right "X", but I need a button that, when clicked, simply closes the workbook instead.

View 2 Replies View Related

Disable A Button

Feb 1, 2010

I have a button on excel form. I need to disable it once user has clicked on it.

I couldnt find name of it on the form anywhere or how to refer it to in the macro.

View 9 Replies View Related

Disable The X Button

Oct 22, 2009

I want to disable the X button on the top right hand corner in excel, but still allow the user with the option of closing the workbook via File and then scrolling down to EXIT. (Not close). I have disabled most of the functions in the Menu bar Close being one of them.

So only Exit is now enabled. When I click on the X it give me the following message as shown below advising me to go to the File menu to Exit, this bit I am happy with. However this is were my problem begins, when I go to File and Exit I get the same message as below and can not exit the application.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "Please select EXIT from the File Menu.", vbCritical, "Cannot Close"
End Sub

View 9 Replies View Related

Excel 2003 :: Shared Workbook - Add Button To Worksheet

Aug 1, 2014

I've added some code the adds a button to a worksheet

Public Sub AddSheetPrintButton()
Dim btn As Button
Dim t As Range
Set t = ActiveSheet.Range(Cells(1, 6), Cells(1, 7)) ' button position
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
With btn
.OnAction = "sheetPrint"
.Caption = "Print Sheet"
.Name = "Print"
.Font.ColorIndex = 10
End With
End Sub

This works fine until the workbook is shared!

View 1 Replies View Related

Enable And Disable Button

Feb 22, 2010

i want to dis able and enable this button using three criteria, and auto paste the comment to other sheet.

View 2 Replies View Related

Disable X Button In The Userform

Mar 29, 2012

how to disable X button in the Userform?

View 2 Replies View Related

Disable Enter Button

May 22, 2007

When you push the enter button while in a cell it takes you to the next cell down. is there anyway to disable that.. or make it so when someone pushes the enter button it tabs to the right?

View 9 Replies View Related

Disable Form Button

Mar 27, 2008

I have a macro associated to clicking a form button.

If possible, if a certian cell value is equal to 0, I want to diable this button. I do not wish for theuser to be able to run the macro associated with that button click.

If found something similar, but in my case, I cannot find the equivalent to CommandButton1, if that's even what I'm using.

If Worksheets("SHEET").Range("A1").Value = "" Then
CommandButton1.Enabled = False

View 9 Replies View Related

Disable Command Button

Apr 13, 2008

The code below is supposed to disable the appropriate command buttons when it's associated cell values are 0.

Private Sub Worksheet_Activate()
If Range("C17").Value = 0 Then
ActiveSheet.CommandButton7.Enabled = False
ActiveSheet.CommandButton4.Enabled = False
ActiveSheet.CommandButton7.Enabled = True
ActiveSheet.CommandButton4.Enabled = True
End If

Not working ..... no buttons are disabled even with their cells are zero. Did I forget something?

View 9 Replies View Related

How Do You Disable Or Delete A Button In VBA

Mar 10, 2009

How do you disable or delete a button in VBA code after the button is pressed?

View 9 Replies View Related

Disable Esc Key And Cancel Button

Feb 20, 2010

I would like some help on disabling the Esc key in a macro and to disable the Cancel button and X on message and input boxes.

My macro is to insert rows in a protected worksheet and another to run a spellcheck, if my users hit any of the above keys during the macro my worksheet is left unprotected and formulas could be deleted in error. I have pasted a copy of my code below,

Sub InsertRowAboveCopyFormulas()
ActiveSheet.Unprotect ("password")
Dim Rng, n As Long, k As Long
Application.ScreenUpdating = False
Rng = InputBox("Enter number of rows required.")
If Rng = "" Then Exit Sub
On Error Resume Next
Selection.Resize(rowsize:=Rng).Rows(1).EntireRow. _
Resize(rowsize:=Rng).Insert Shift:=xlUp
Selection.Offset(Rng).AutoFill Selection.Resize( _
rowsize:=Rng + 1), xlFill
Selection.Resize(Rng).EntireRow. _
ActiveSheet.Protect ("password")
End Sub

View 9 Replies View Related

Disable X (quit) Button

Jun 11, 2007

I'm sure there is a way to disable the 'X' (quit) button in the top right-hand corner of the EXcel application (not the 'X' for individual workbooks), or the hook the quit event so that I can run code that shut down the application cleanly? I'm sure a Windows API call is involved but do not know enough about that side of programming to know for sure.

View 4 Replies View Related

Disable Worksheet Button

Jul 27, 2007

I have buttons on each of my sheets, when one is clicked code is called in my module ("modAPI"), and from that code I wish to disable and enable certain buttons, and/or change the caption of those buttons. However when I try to do:

With ws
btnRefresh.Enabled = False
End With

I get Error 424, Object Required. I've tried recording a macro of what I wish to do, and it gives me ActiveSheet.Shapes("btnRefresh").Select, but this doesn't give me the option to enabled/disable or change the caption of the button.

View 3 Replies View Related

Excel 2010 :: Command Button In Shared Workbook Not Working?

Sep 7, 2010

I am using Excel 2010. I am using a shared workbook that was originally created in Excel 2003. This workbook has a command button that is supposed to be clicked to open a userform. However, I cannot even click on the button when opening the shared form in Excel 2010. When the form is not shared, the button works fine.

I have no problems with the button when opening the shared form in 2003 or 2007.

Is there anything I can do to make the command button work while the form is shared and while using Excel 2010?

View 4 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved