Bug 35593 - macro themecolor - tintandshade - patterntintandshade are all problems.
Summary: macro themecolor - tintandshade - patterntintandshade are all problems.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2011-03-23 08:14 UTC by jkonecny
Modified: 2020-07-04 04:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

tintandshade demo file (23.76 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-07-04 04:51 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description jkonecny 2011-03-23 08:14:30 UTC
The macro below which which came over from an unknown version of excel does not run.  themecolor - tintandshade - patterntintandshade are all problems.

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Sub WhiteReset()
' WhiteReset Macro
' Keyboard Shortcut: Ctrl+w
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .PatternTintAndShade = 0
    End With
    With Selection.Font
        .ColorIndex = xlAutomatic
        .TintAndShade = 0
    End With
End Sub
Comment 1 Noel Power 2013-02-05 14:31:48 UTC
marking this as an enhancement, I don't currently have plans to look at this so putting back to default
Comment 2 johnks 2020-07-04 04:51:58 UTC
Created attachment 162626 [details]
tintandshade demo file

BASIC runtime error.

attaching this file containing tintandshade. removing this from the macro makes the macro work just fine