Search:

Thanks!!! That was it!
--cat

I benefitted from your help recently. Now I need more. The following code recommended by Andrew works great to disable the "Save As" in a template. However, it does not disable the "Save". Is...

Thanks, both of you. I will let you know --cat

Hi, ... I'm in a regulated environment. I have created a template for my users. Because of the regulation, my users are not allowed to save the document at all, they can fill it out and print it...

I'm trying to place all of the Microsoft templates into one folder since our workgroup templates have so many folders/tabs now. In Office 95, I was able to do this easily. However, now I only seem...

Thanks, Sam. I discovered that this particular Excel file was part of the DaCS for MS Excel (for 21 CFR Part 11 compliance), so many Excel functions don't work the way they are supposed to. --cat

I've hidden columns and added filters to three columns, then added a new custom view. I checked both the "Print settings" and the "hidden rows" options. However, when I click on the Show button, I...

Thanks, John, for your time.
--cat

Sorry ... we use Windows 2000 and Office 2000 throughout. I did use the email button -- this works, but it sends the entire sheet. I need just a selection. Our default settings are RichText. I...

Hi, any help/hints would be appreciated. I'm starting a new job and whenever I paste from Excel into an Outlook email message, the pasted portion of the message does not get sent. It appears to...

Thanks, Legare. I had written "Brute Force" code, but it covered more area than I needed and was time-consuming. I do appreciate your help.

Hi Legare. I am sorry. I did not give all the information. I have a value in cell AA1 that will dictate how many cells in column B (starting at B9) that need to be formatted in this fashion.
It...

Hi All ... I have attached a file with a macro. This macro attempts to Bold the first two lines of B9 and B10, and italicsize the 3rd line.
It uses the lengths that are in columns K,L, and M.
...

Thanks Andrew

Hi All -- and thanks for all the help yesterday ...
(it seems every time I do something with this lounge's help -- I am asked to do something more!) <img src=/S/dizzy.gif border=0 alt=dizzy...

Thanks Wassim, ... again, you have been very helpful!

Hi All ...

In cell B2 I have a number that can change.

I need to autofill a given selection by that cell's value
I recorded the macro autofilling from row 7 to row 15.


...

Thanks Rory and Wassim,

I ended up using this formula in a new column:

=IF(ISERROR(FIND($B$1,E1)+FIND($B$1,J4)),0,1)

The user then enters the word or phase in Cell B1, clicks on a macro...

Hi Wassim,

ummm, say "Hi" to Sebastian for me. Whose Sebastian?

Yes, this will work great. I had tried to concatenate the two columns into another column, but one of the columns was pretty...

Hi All .. .

I am using autofiltering. I would like to get all the rows that contain a certain word in either column E OR in column J. If I do a custom filter in Column E, I have limited my rows...

Sorry, HP. I thought the original post was "too general" and that no one would help me then. I am now trying the WorkSheet_Calculate event. Thanks again.

Hi All ... I have a macro that will apply a list data validation to a given cell. The list is based on a named range. This named range varies based on the value of another cell. My question is...

Thanks, Andrew and Rory, ... I need the formula so I'll live without or work-around the Bold issue.

Thanks, Rory, that did work!
One more thing (don't we all say that!) ...

=concatenate(F5,char(10),G5)

How do I make the F5 Bold and the G5 part not Bold?

Hi All, this is probably very simple ...
I want to concatenate the contents of two cells, but I wish to have a new line between them. If I were typing it, I would enter a "Alt + Enter". So what...