Search results for query: *

The help files from Microsoft say to click on "rename" to get the columns to say what you want them to, but the rename function is grayed out & can't be selected. I'll be playing around with your suggestion today. Again, thanks for all the help! -Dave the Perpetually Confused

Okay, of course that was too easy of an answer. I need to add columns that have not yet been defined. I see that there are columns titled "text 1", "text 2", etc. But I can not figure out how title a column "Outage Description". I know these defaul values have to be installed somewhere, but I...

Okay. I'm working on the new table now (I found it in Project) and will let you know if I need anything else. You are (if I may say!) da man! Have another star... -Dave the Perpetually Confused

Okay, I'm back with more goofy questions about custom reports. I think once I get these all figured out I'll be set. I now know how to make custom reports and get them onto the enterprise global so that everyone can use them. But I do not know how to specify the columns for the reports. From...

By the way, COMPLETELY off the subject, but I used to love PDQ Bach and have even been to a concert. Odd music, but amazingly compelling. Just thought you might want to know that someone knows what your handle means... -Dave the Perpetually Confused

What can I say, I'm new at this. It was a case of, "He likes to work on computers, let's put him into the position of administrator! No experience? Aw! He'll figure it out!" The old OJT special... -Dave the Perpetually Confused

One last note, I found the issue and it has nothing to do with the Global.mpt file. I had to copy the report to the Enterprise, not the global. Thanks for the help, though. You sent us in the right direction. I wouldn't have gotten it without your input. Thanks again! -Dave the Perpetually...

Yes, that's what I did-sorry for being too cryptic. I will check the installation to see how it was put in. But you gave me another out, too! Have a star on me. -Dave the Perpetually Confused

I have created a custom report for my managers to use. I turned this into a global report, but they still can't see it. Is there a way to make it so that everyone can use this custom report? -Dave the Perpetually Confused

No protection. -Dave the Perpetually Confused

My co-worker is experiencing weirdness when trying to open an Excel file in a SharePoint portal page. It is pulling it up as an Excel file directly in Explorer, but her standard choices are not allowed (File, Edit, View, etc.) She can use some of them, but not anything that will allow...

Okay. That sounded sarcastic. Seriously, thanks. I got some emails and tried a few things that didn't work. Reinstalling was the only thing that worked. -Dave the Perpetually Confused

I uninstalled and reinstalled and not it works fine. Thanks for all the help! -Dave the Perpetually Confused

On Error GoTo cmdReformat_Err If Left(Range("B1").Value, 1) <> "L" Then MsgBox "This sheet has been altered and can not be re-formatted. The reformatting will not be correct!" End If '-- save the backup copy of this file ActiveWorkbook.SaveCopyAs cstrBackupPath & Month(DateTime.Date) & "-"...

The files are all located on a network and are accessed from the same area by all users. My PC just doesn't want to play well with the other kids' toys. -Dave the Perpetually Confused

...in our shop, and I am the only one that is having this trouble. The error reads: The error could not be accessed. Try one of the following: * Make sure the specified folder exists. * Make sure the folder that contains the file is not read only. * Make sure the file name does not contain...

I knew that was going to confuse people. I just wanted to include the color stuff so that you could see how I've started. I need to count the cells that have the font strikethrough. I have the colors already. (Sorry!) -Dave the Perpetually Confused

I know this is foolish. I have a spreadsheet that is color coded beyond belief. Because of its complexity, we need to be able to count how many of each color are in the range. I have that one figured out by using the following: Function CountByColor(InRange As Range, _ WhatColorIndex As...

Thanks, guys! Worked like a charm. I was putting commas in like it was Excel. Have a star, Macropod! -Dave the Perpetually Confused

Calculating backwards. I had it set up right the first time, but he decided I needed to put the amount in C1 so that it calculates A1. -Dave the Perpetually Confused