setting

  1. C

    Force print settings to 'Print Active Sheets' (Excel 2016)

    I'm using the following code to provide the user with a Print Preview/Print Settings page: Private Sub PrintPage1Button() 'Set up Print Preview With ActiveSheet.PageSetup .PrintArea = "B1:T56" .Orientation = xlLandscape .LeftMargin = Application.CentimetersToPoints(0.5)...
  2. M

    Quick array question

    Can anyone give e the syntax of how I'd create a variant array without setting the dimensions beforehand or using a range on a sheet At the moment I basically Dim unclosed_liabilities_array As Variant then set the array by finding the last row and selecting an empty space on the sheet...
  3. R

    Excel returns dd/mm/yyyy as 1/0/00 when performing time calculations.

    Hello, I have been trying to locate a quick fix but can't remember where I had seen it. Something about my excel workbook not having the correct format in the setting or something like that. I am using the cloud version of Excel. Thanks in advance for your assistance and time.
  4. S

    setting "relative to original picture size" to true in comments...

    I have the following to set "shadow" to false but don't know how to do the same for the "relative to size" setting to true. Sub Comments_Format() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Shadow.Visible = msoFalse Next cmt End...
  5. T

    ScreenUpdating, EnableEvents settings

    If in a single session of Excel, I have two workbooks and in workbook 1 I set ScreenUpdating and EnableEvents to be False, then close it, are the states for workbook2 still set to False? I'd like to test it but I have found that despite setting ScreenUpdating to False, when I check it in the...
  6. B

    Macro or default setting for past special

    Hi, I have a programmable keyboard and currently have a copy and paste button assigned. I am trying to make my paste button default to paste special. Is there a setting or something like that to set in Excel?
  7. C

    Locking regional date formatting in the spreadsheet to UK

    Hi I am making a spreadsheet form for some of our guys to use. This spreadsheet will be used on numerous computers with different regional formats. I am trying to make the data entry into some cells be "dd/mm/yy hh:mm" and it will display "dd/mmm/yy hh:mm". This works fine if the computer's...
  8. F

    Need to disable macros or view VBA code

    EDIT: Resolved - Disabled Trusted Documents So... I've coded myself into a corner. Upon opening my file, I have a userform that pops up requiring the user to make a selection before they can proceed to the excel file. I accidentally disabled the button that would close the userform and allow...
  9. F

    Error when trying to set worksheet

    I'm getting a "Subscript out of range" error when trying to set MonthlySells - why is that? The tabs exist in the workbooks so that can't be the reason. Dim SCSAttribution As Workbook Set SCSAttribution = Workbooks("SCS Attribution") Dim AXATransactions As Workbook Set AXATransactions =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top