Archives december 2022 - Kazam Trainings

20 december 2022

Execute a Macro on Multiple Workbooks

Written by kazamraza no comments

Classified in : Visual Basic for Application (VBA), Macros Tags : none

I want to execute a Macro in worksheet 1 on multiple workbooks in a folder.

VBA Code

20 december 2022

Set all sheets' fill color to "No Fill" using VBA in excel

Written by kazamraza no comments

Classified in : Visual Basic for Application (VBA), Macros Tags : none

How can I Set all sheets fill color to No fill using VBA in excel (all cells). Same as select all sheets, Select all cells (Control+A) and change fill color to No fill.