User Profile
666_666666
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
- 985Views0likes0Comments
VBA excel dropDown customUI trouble
SelectedIndex = None InvalidateControl this "code" deactivates the item in the dropdownlist , but there is no redrawing (the list item is not active, but is displayed) #according to the manual, invalidate should initiate redrawing if I switch to another tab with my hands and return to a custom tab, the element is not displayed (this is the result I need) please tell me how I can force excel 2016 to redraw the ribbon or switch to another tab1.2KViews0likes3CommentsRe: Conditional Formating copy VBA
ThisWorkbook call my add-in (.xlam) the macro is run from the add-in as I understand it, when I open the template file, it will become active we need to get back to the file.xlsm somehow PS it's magical! .Name works the way it was supposed to be solved through it thank you so much for your help... I don't understand how it works, but I figured out how to dig into the names of windows only after your answer... non-trivial, I'm used to using the full name (path+name+extension)5.5KViews0likes0CommentsRe: Conditional Formating copy VBA
Run-time error #("RTE" on next) Class not registered When add paths Without paths RTE 9 Subscript out of range if I use the names of windows it works thank you, at least I understood that I should try to test for search New question how to get the names of windows, the active document, and the template that opened later , the fact is that excel changes the name of the window to another one... the template file is 0.xltx and the window is called 01 (without extension)5.5KViews0likes2CommentsRe: Conditional Formating copy VBA
From what sheet 1st and in what range is all in the file.xlsx do you want to copy formatting to which sheet 1st and in what range is all in book.xlsm? in .xltx I have a rule that applies to the entire sheet XML code from .xltx ... - <conditionalFormatting sqref="A1:XFD1048576"> - <cfRule priority="1" dxfId="0" type="expression"> <formula>xxx</formula> </cfRule> </conditionalFormatting> ...5.6KViews0likes4CommentsRe: Conditional Formating copy VBA
HansVogelaar could you give an example of the code accessing the file.xltx copying a rule from there and applying it to a previously opened sheet of the book.xlsm the fact is that I have already tried, either I don't know something, or you have a different version, not 2016 excel5.7KViews0likes6CommentsConditional Formating copy VBA
I can't figure out how to copy conditional formatting rules the task is to copy a rule (not a cell format, but a rule) from, for example, a file.xlsx (not necessarily this type, any format that supports storing conditional formatting rules is interested in) and apply it to a previously opened workbook containing data ... and all this must be done on VBA in excel 2016 (to support versions starting from 2016) without connecting third-party libraries or using third-party applications (to avoid communicating with permissions) everything I could find doesn't satisfy at least one concept Please help6.4KViews0likes10Comments
Recent Blog Articles
No content to show