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)
Version:
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2011-03-23 08:14 UTC by jkonecny
Modified: 2019-09-19 11:07 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

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
'
    ActiveCell.Range("A1:B1").Select
    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