Search:

Hello all,
Is there a way to change the default colors (those you see when applying font or background color) in all the Office 2012 applications.
We want to incorporate our company colors in the...

Hello all,
I just learned that my company will introduce SharePoint this year and will make all current network drives obsolete.
I use a lot of linked Excel workbooks and have a lot of VBA macro's...

Thanks Rory,
It works!

greetings,
Patrick Schouten
The Netherlands

Hello All,

Is it possible to detect the current running Excel version from VBA?
I have a applictaion in Excel 2003 that will not work in Excel 2007 (because of home made menus and toolbars). And...

Hello Paul,

Even after searching and reading al lot of posts, I did not find this one.
So thanks for pointing me to it. It seems in de code is enough information for me to create my own code.
...

Hello all,
I would like to use an Excel sheet to run a macro that will update the paths of all linked tables of all the word documents in a given folder.
I have seen how to check what the code is...

Paul and Andrew,
Thank you both for your quick respones.
This code will get me further.

Greetings,
Patrick Schouten
The Netherlands

Hello,
I am creating some VBA code to strip selected parts of a Word document.
But the document I am working with is a master document.
What code do I use to save a copy of the master document...

Hello,
I want to open a PPS (powerpoint slideshow) from a Excel macro, but have no clue what so ever how I should do it.
Anyone a suggestion form me?

Thanks
Patrick

Try Pieterse's Systematic Approach to behavioral Problems in XL.

Yep... Deleting the XLB file corrected my problem.
So now I have can change Excel to the way I like it again.

Again, Thanks...

I haven't seen Excel 2009 yet http://windowssecrets.com/forums/images/smilies/evilgrin.gif

Try Pieterse's Systematic Approach to behavioral Problems in XL.

Thanks I changed it in 2003 ...

Hello All,
When right clicking on a 'column name' the shortcut menu does always show the 'insert' option grayed out.
When using the normal menu 'insert' the option 'column' is available and works....

Thanks,

It works.

greetings,
Patrick

Hello all,
How could I check with VBA if a worksheet is protected?

Thanks in advance for your answer
Greetings,
Patick Schouten

Hallo Hans,

Thanks for the quick and correct response.
It is working great.

Greetings.
Patrick Schouten
The Netherlands

Hello all,

I want to hide or unhide some columns on a totalsheet depending on a value in a cell on that sheet.
This cell is the 'result' of cells from other sheets. So I was thinking; if the user...

Hello Don,

Thanks for your reply.
Unfortunately I am not able to check this because of restrictions our company sets on user accounts.
But I will discuse this later on with out IT department.

Hans,

Thanks for the effort.
My conclusion is that this seems to be a local problem. So I will take it up with our IT department.
Thanks

Hello Hans,

No, I create to buttons by hand in the document and than change the properties to give them a proper name.

Hello All,
I created a Word document with fields, sections and command buttons. Every section is protected / blocked except the section that the user has to work in.
After the user has filled the...

You are a livesaver.
Thanks, you hit the nail on it's head

Hello All,

I have some merged cells in my sheet and they have there own name.
The strange thing is that when Í select the cell en change the properties to locked = true it is all okay,
but when...

Hans and Jan Karel,
I'm sure that the solution of Hans will work, but i'm using the short version of Jan Karel.
It works perfect.
Thanks.

Hello Hans,

You are a livesaver.
Thanks it works perfect

Hello All,

I'm creating a macro that will open some workbooks and copy the contents of sheets form workbook 1 to workbook 2.
Both workbooks are almost simulair and make use of the same named...