View Full Version : Merge Cells and keep format everyday

slamet Harto
09-10-2008, 10:32 PM
Dear team,

Can you teach me, if I want to format a sheets (sample attached).
Then, I need to save the code given in my personal.xls. However, I can't save this code in C:\program file\...\Xl Start as this drive is protected and resctricted for user. Is there a way to do this?

Thanks a bunch.
Rgds, Harto

Bob Phillips
09-11-2008, 12:58 AM
If XLSTART is protected, could you create an addin that does it, and save that somewhere?

slamet Harto
09-11-2008, 01:26 AM
Hi Bob,

You are right. It can be saved in Addins Folder instead of XLStart.

Please teach and send me your VBA code.
Many thanks for your assistance.

Rgds, harto

Bob Phillips
09-11-2008, 02:28 AM
I don't have the code, you do. Just save the workbook as an addin, .xla instead of .xls, and then install the addin via Tools>Addins.

slamet Harto
09-11-2008, 03:54 AM
Hi Bob,

Please help on my previous post. I have two problem on this threat.
Case 2 is already been solved but Case 1 is what is the VBA code to format/merge some cell. (see my attached file on prev post)

Can you teach me, if I want to format a sheets (sample attached).

Thank you & rgds, Harto

Bob Phillips
09-11-2008, 04:49 AM
What does the data look like before the formatting.

slamet Harto
09-11-2008, 04:53 AM
Just like a sheet normally. No data/format at all.

Thanks bob

Bob Phillips
09-11-2008, 05:00 AM
Can you post it with a before andfter exammple?

slamet Harto
09-11-2008, 05:12 AM
As like we open new workbook

After: (see attached)

Thank you

Bob Phillips
09-11-2008, 06:01 AM
Are you saying this will be created from scratch, there is no data to reformat? If so, do it in Excel with the macro recorder on, you will have your code.