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


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 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

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 2010 :: How To Reset Workbook Default Format To General

Jan 25, 2011

Using Excel 2010 - I have a large workbook with multiple worksheets - been using it succesfully every day for a long time. All of a sudden every empty cell, and any cell not specifically formated in every worksheet has a default cell format of Time. Any new workbook created is OK.. defaults to 'General' - But, if I add a new blank worksheet to this particular workbook it defaults to 'Time' format. How did the default cell format for this workbook become set to 'Time' from 'General' and how do i fix it?

View 2 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

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

Can I Change A Setting Somewhere To Make Close Its Default Blank Workbook When I Open An Existing One

Feb 9, 2007

I have Excel 2002. If I start the program it opens with a blank workbook, called "Book 1".

If I then open an existing workbook, I have two Excel buttons in the Windows taskbar: the one I just opened, and the blank one titled Book 1.

At work I have Excel 2003. The blank "Book 1" is also there when I start the program, but if I then open an existing workbook, the Book 1 goes away. I like this way better.

My question is: Is this just the way versions 2002 vs. 2003 work, or can I change a setting somewhere to make Excel 2002 close its default blank workbook when I open an existing one?

View 9 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

Excel 2010 :: How To Disable AutoFit

Dec 6, 2011

Every time I type a number too large for a column, Excel resizes that column. This is definitively not what I want to do. I googled a lot and looked at all options, but I could not find a way to stop this behaviour.

how to disable any Autofit initiave from Excel 2010?

View 3 Replies View Related

Excel 2003 :: VBA Radio Button Reverts To Default State

Mar 13, 2014

I have an excel file containing 50 sheets which we use as an accreditation test. Each sheet contains one question to which there are several possible answers. These answers (for example, A, B, C and D) are option buttons and when a user selects one, that selection is recorded as their response which is then marked. After answering a question they click a NEXT button to move on and as they move on the previous sheet (question) is hidden so they only ever see the current question sheet.

This has worked well for us for a few years, but we have just noticed some odd behaviour on ONE SPECIFIC sheet. The option button the user selects on that sheet (it is actually question 13 in the sequence) is not stored after the test is completed. However on every other sheet, the selection is stored fine - just this one sheet. The properties of all objects on the rouge sheet are the same as the other sheets. I have duplicated a working sheet and tried replacing the question 13 sheet to try that, but the problem persists.

I tried deleting that Q13 sheet and running the test without it and the same problem occured but this time on the preceeding sheet (question 12) which suggests it is not the actual sheet that is causing the problem.

This is the vb code we have on each sheet

Option ExplicitDim Response As StringDim q13 As IntegerPrivate Sub cmdQ13_Click()    q13 = 0
If optq13a.Value = False And optq13b.Value = False And optq13c.Value = False And optq13d.Value = False Then
Response = MsgBox("You must answer Question 13 by selecting one of the options!", 16, "More Information Needed !")        
[Code] .....

So in this example there are 4 option buttons and 1 command button. It is no different to the other 49 sheets

View 2 Replies View Related

Excel 2010 :: Default File Location Not Working?

Apr 19, 2013

I'm using Excel 2010. When I go into the Excel Options, to the Save option and try to type in a specific network drive in the Default File Location: box, I click OK and then it doesn't save the changes. I close Excel down all the way and then restart a new Excel session and it keeps going back to "LibrariesDocuments..."

It doesn't seem to be just related to Excel...having the same issue in Word and Access 2010 as well.

View 3 Replies View Related

Excel 2010 :: Changing Default Text Box Settings?

Sep 5, 2012

When I place a text box in Excel 2010, the default is for everything to be locked (Box is locked AND text is locked). I want to change the default setting so that when I start Excel fresh, anytime I place a text box the "LOCK TEXT" box is UNCHECKED.

There's a place where you can select "Set as default text box") after you make the changes, but it's not sticking (even in the same document without closing. IE, I make the changes to a text box, then click the option that says "Set as default text box", place a NEW text box immediately in the same document but the text is still locked.

View 3 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 :: Changing Default Blank Page Settings?

Apr 23, 2012

My office recently upgraded to Office 2010 and we would like (in the accounting department that I work in) to change the default number formating in a blank sheet to Number, 0 Decimals, using seperators, from the current default of general format number.

I have looked for the Book.xltx file to replace but can't see it any where.

View 5 Replies View Related

Excel 2010 :: Date Picker To Default To Named Range

May 6, 2012

I am new to VBA. Using Excel 2010. I have a date picker on a userform named LtPayCalFm1. I have created a named range on a sheet within the workbook called LQD which is a date. I want the date picker to show the date LQD when the form opens. The code I have is


Private Sub LtPayCalFm1_Initialize()
Dim LQD As Range
DTPicker1.Value = LQD
End Sub

I get Run time error '380': Invalid property value How do I correct this?

View 7 Replies View Related

Excel 2010 :: Disable Something Like Text Box Related To Cells?

Aug 4, 2014

I am using excel 2010. When I click on cells on one column, something like text box will pop up with information related to that column. How can I get rid of this text box. How to disable this text box which I think it has a link between the text box and cells on that column.

View 1 Replies View Related

Excel 2010 :: Disable Import Data Dialog Box?

Apr 23, 2012

Is it possible to disable Import Data Dialog box in Excel 2010? I have a web query file. I want to copy its content and paste in a new worksheet under an existing workbook. I have a macro which does that but I get Import Data dialog box when I tried to paste the copied content from test.iqy file to new sheet. The dialog box has

Select how you want to view this data in your workbook?
By default Table is selected, which is fine.

Where do you want to put the data?
By default New workbook is selected. I want to have Existing worksheet selected by default.

Is there a way to set these requirements into vba code and make this dialog box not appear at all?

View 2 Replies View Related

Excel 2010 :: How To Completely DISABLE Spell Check

Feb 28, 2013

We're setting up a test for candidates in an Excel 2010 workbook and want to get a sense of their native ability to spell. We'd like to disable spell check for the entire workbook. I've looked in Options>Proofing, even tried removing the dictionary, but haven't found a way to completely disable spell check from working. Is it possible to achieve? We'd settle for being able to disable spelling within a textbox.

View 7 Replies View Related

Excel 2010 :: Highlight Active Row - Change Default Border And Fill?

Jan 13, 2013

Using Excel 2010. Is it possible to change the default line thickness and fill color when selecting the ActiveSheet Target Row below?

I would like a thin border and a light grey fill - without interfering with any fomatting or conditional formatting that has been applied to the worksheet.

View 1 Replies View Related

Excel 2010 :: Change Default Pie Chart Colors In Recorded Macro?

Mar 20, 2014

I am working on a project where I am virtually almost finished except for a minor change with the pie chart. I am analyzing some data and recorded a macro to do this and also the pie chart for visualization. However, I do not like the color of the default pie chart colors and would like to customize it. How could I change this within the macro I have recorded?

[Code] .....

View 4 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

Excel 2010 :: Deleting Conditional Formatting On Either Close Or Open

Jul 27, 2012

I have a problem where Excel 2010 is deleting one of my conditional formatting conditions. I do not know if it is deleting it on open or close. I just know that I enter the conditional formatting, save the workbook, close the workbook, reopen the workbook, and it is gone.

The other conditional formatting conditions (simple "Cell is Blank") are left intact.


Cell with conditional formatting is on sheet "MyRecord" at "$E$7". A corresponding boolean value on separate sheet "Data" and must be referred to by using "OFFSET" with a record locator value (workbook level named range "RecordLocator") that leads to corresponding data row, so looks like following:


When I configure this, it works great until I save and close the workbook. When I reopen the workbook, this particular conditional formatting is gone with all other conditional formatting left intact.

I've tried using the actual range address in place of range name "RecordLocator", changes nothing.

I can't figure out why Excel deletes this particular conditional format.

View 3 Replies View Related

Excel 2010 :: Changing Default Chart / Graph Format Copied When Pasted Into Word?

Aug 28, 2012

I work with a team of users that are continually publishing reports in Word that contain charts and graphs copy and pasted from Excel into Word 2010.

We have a custom script that leverages a PDF engine to automatically convert .doc files to .PDF files that we distribute electronically to our clients. This all works great, but only if all my users select 'paste special' and Enhanced Metafile Format when adding their excel charts into our reports. Most of these people aren't tech savvy, and I'm havin ga hell of a time getting them to follow this workflow and am hoping there's a way in Office 2010 to select the default paste from excel into word when the content is a chart.

It seems like the default paste from excel is an embedded chart/graph that you can then further manipulate each component of the chart in Word; the default doesnt' paste an actual image. I am assuming the pdf renderer is using a lower resolution .PNG version of the image and when these are scaled for print and or pdf, they look like crap.

Is htere anyway I can automatically change the default paste format for the chart from excel into word to be an EMF/EMV (enhanced metafile?) Either thorugh the registry or some other saveable setting?

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

Default Close On Userform

Apr 23, 2006

is it possible to remove the default close (X) on a userform? Or maybe some code with a message to insist the user choose a option first

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

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