Search results 60

Sorted from new to old.

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

May11

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

Apr30

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

1 2 3 4