Saving templete / workbook to a specific drive / file

I have a workbook template which when team members use it and the they go to save it defaults to “my documents” and I would like to set up a macro to save it to a particular drive / file location. Below is one that works for a word ...

Message posted on the September 29th, 2010 - 2:26 PM ET

Saving templete / workbook to a specific drive / file...trying again

The macro below works but... it’s a bit confusing for the end user in that I does save the file name as A1 to the right drive / directory – however it does show the end users it has done that. It will also change it again if A1 is ...

Message posted on the October 2nd, 2010 - 1:55 PM ET

Using a Windows Shortcut to Open to Specific Sheet in Workbook

I want to be able to create a shortcut icon to each individual sheet inside of one workbook. Is this possible? I am aware that there are macros that you can use inside of Excel to make the workbook always open to a specific sheet, but this is not ...

Message posted on the December 22nd, 2009 - 10:13 AM ET

Protecting worksheets from view on shared drive

Is it possible to create a workbook, with multiple worksheets to load onto a shared drive, but to hide from view each worksheet assigned to a group. For example, I would like to create a workbook with 5 worksheets, where the data on the five sheets ...

Message posted on the April 3rd, 2009 - 4:22 PM ET

Protect Workbook

I am trying tio figure out how to protect a workbook that will be on a shared drive were many people will have access to specific cells on it. Also I need them to be able to select a range and copy that range and paste it into powerpoint. There are ...

Message posted on the June 4th, 2009 - 11:00 AM ET

Give a sheet a name from data in a cell-saving to a specific folde

I have a blank worksheet (call it no name) and want to use the data in cell E11 (e.g.data could be 18208C) to rename the worksheet (eg to 18208C) I then want to save the workbook with the same name as the new worksheet's name (ie as an example ...

Message posted on the May 22nd, 2009 - 11:20 PM ET

Highlight selected cells only

I have a macro on sheet (1) that takes me to a specific cell on sheet (2). I need the now selected cell on sheet(2) to highlight to some color (yellow probably). The macros on sheet (1) are along side a long list of names. So as I select the ...

Message posted on the May 5th, 2009 - 7:55 AM ET

QAT does not allow enough room for customization - please help

I posted the paragraphs below on a message board (http://www.exceluser.com/explore/surveys/ribbon/ribbon-survey-results.htm) some time ago. My company's #1 client has migrated to 2007, and are were forced to do so in order to maintain our ...

Message posted on the April 20th, 2010 - 1:42 AM ET

Finding cells that contain references to other workbooks

Howdy - How do I find out what cells in a specific workbook contain the formulas that drive the link to another workbook? Simply put, I have a lot of workbooks I inherited and have old links I know I do not need, but I can't figure out how to ...

Message posted on the October 21st, 2009 - 10:27 AM ET

UNC filepaths appearing

Hi I work with lots of Excel spreadsheets each day and I have encountered a problem with linked workbooks. In my office we have a naming convention for shared drive locations e.g. z:... is the mapping to one specific network location which has a ...

Message posted on the August 4th, 2009 - 8:25 AM ET

Custom Excel Toolbars - how?

Is it possible to build multiple custom Excel toolbars and completely remove the ribbon? Before anyone tells me 'try it - you may like it!', please read the following: In my company, we use Excel as a meeting facilitation tool, and have built a ...

Message posted on the April 1st, 2009 - 1:05 PM ET

workbook specific drive