If you are using Excel 2007 (not sure about other versions) there is another option available. From within Excel, you can specify a particular folder on your PC as being trusted. Any excel file containing macros opened from that directory will open seemlessly.

You can actually specify more than one folder as being trusted, but what I do is to have a single folder in which I store all Excel files with macros that I trust. I then create shortcuts to the files in the (untrusted) folders that I would have stored them in if it wasn't for the macros.

The "Very High" Security Level within Excel 2003 "appears" to offer a "trusted locations" option, but when you select this, it doesn't seem to offer the option to specify the location. I've tried looking in the Help, but it's not much use in this respect.

If anyone knows how to do this, it would be useful here.

The other way of doing it is for the author to digitally sign the macros from within Excel, and then when you open the Workbook with Security Level Medium, you can get the option to add the author as a Trusted Publisher. But to do this, I think the author has to obtain a Digital Certificate, which I don't think are free

Rgds.


Les.

With Excel 2007, you get to it by selecting "Excel options" followed by "Trust Center". Pressing the "Trust Center Settings" button brings up the "Trust Center" window. From here you can select a number of options. The ones relevent here are

- "Trusted locations" where you can manage trusted folders including adding new ones, and
- "Macro Settings" where you can chose what Excel does about macros in files not in a trusted location.

I have this "Macro Settings" set to "Disable all macros with notification". With this setting Excel will let me chose what to do about macros for files stored in a "normal" location and open files in trusted locations with macros automtically enabled.

Thanks Les, very wierd it was a copy and paste from a posting on AVforums. The links work there but for some reason don't survive the clipboard

Here they are (hopefully )

http://www.4shared.com/file/10021431...ableWatch.html

http://www.4shared.com/file/10021432.../OneCable.html

http://www.4shared.com/file/10021434...leSuggest.html

http://www.4shared.com/file/10021437...ableWatch.html

http://www.4shared.com/file/10021439.../TwoCable.html

http://www.4shared.com/file/10021441...leSuggest.html

Graham
Last edited by grahamlthompson : 22-04-2009 at 12:00

The Trust Centre, nor Trusted Locations, appears to be present on Excel 2003, but thanks anyway.

I've got Office 2007, but when I installed it for my daughter on her PC, I really didn't like the interface at all, I couldn't intuitively find my way around it, and I don't do manuals

I'll stick with 2003, and it really isn't that much effort to press the "Run Macros" button when opening the file.

Rgds.


Les.

Les,

Comodo offer free Digital Certificates for email, I don't know if it could also be used to sign macros - http://www.comodo.com/products/certi...ces/index.html

The signup page does mention X509.

I hated the Office 2007 interface when I first installed it, but I was updating from Office 1997 so I stuck with it. It took me a long time to get used to it (I also don't do manuals) but, now that I have, I find it a lot quicker to navigate than 1997. I doubt if there would be a lot of point in upgrading from 2003, though.

Someone sent me spreadsheet from Excel2007 with vba code. I could not even view it in Excel2000. If anyone want's to distibute code to earlier versions it might be wise to stick to an earlier version. (Unless someone out there knows how to make 2007vba accessible to earlier versions)

Microsoft do a free 2007 compatablity download for Office 2000, 2002 & 2003 see:
http://www.microsoft.com/downloads/d...displayLang=en

It may not be the VBA code that's the problem, but the way in which the spreadsheet was saved. Excel 2007 has its own format (.xlsx) which it will default to. Even the simplest of spreadsheets saved as a .xlsx file won't open in earlier versions. Excel 2007 does have a "Save as Excel 97-2003 Workbook" option (which can be set as the default). This saves to .xls format. If there are functions in the workbook that won't convert to .xls, you will be warned. I always save to .xls if I'm sending the file to someone and I've had no problems with speadsheets containing VBA code (but that may be because my VBA efforts have been very basic). Most of the issues I've seen have been cosmetic.

If you get a .xlsx file from someone, ask them to send it again as .xls. It should be easy enough for them to do.

It was a .xls file, I could open it and run the code but not view it or edit it any way

OK. I thought you were saying that you couldn't open the file or use it in any way. The .xls version of the code is obviously 2000 compatible otherwise you couldn't run it. Odd that 2000 won't display the code for editing. I assume you have the VBA plugin installed. [Note: Not quite sure whether that's what it's called, or whether it's relevent to 2000. What I'm remembering is that, with '97, the VBA editor was a seperate component which was not installed by default.]

It's installed by default, using the same version of Excel used to write the record clash application.

Talk Sport radio added to record clash app - no change in download link

2 channels deleted and channel 205 transponder change - link unchanged

Todays changes uploaded

142 BET HD added
401 Name Changed to Wedding TV Asia (was Wedding TV + 1)
801 Price Drop TV transponder change

No change to link

Auto channel scan just removed BET HD. Record Check10 updated, DIY mod

Delete ROW 31, change Cell E1 to 148

With thanks to Savvy who spotted some inconsistency in the results.

For both single and dual options programme incorrectly identifies channels 208, 513 and 801 as viewable with ITV HD as one of the recordings

Similar bugs in single cable and dual cable suggestion and what can I watch fixed

West Country (Exeter) post code now default due to ITV1 picture quality

For anyone interested the problem was due to ITV HD having the same transponder frequency but differing polarity to some channels on Astra 2.



http://www.4shared.com/file/11660217...dCheck011.html

Found a bug in V11.

Select Dual Cable
Select First Recording = 108 BBC HD
Select Second Recording = 101 BBC 1 E Mids
Click on Alternate Watch Options

The Two Cable Suggestions box pops up, but is blank and Excel has been crashed - End Program is required.

I am in the East Midlands, so my first four rows are as follows:-

101 BBC 1 E Mids 10788 V
102 BBC 2 England 10773 H
103 ITV HD (red button) 11426 H
103 ITV1 Central E 10832 H

Geoff

If you leave it for a while, it comes up with a VB overflow message, you don't have to End Program.

I think there are too many permutations with all the Regional BBC1 channel options.

I think we had this in one of the earlier versions, and Graham put a limit on the output.

I'm sure he'll be along soon.

Rgds.


Les.

so it does - on the case

Les I have sorted it out it works now I think same link.

Thanks Geoff try downloading again

Yes, that works fine now.

Thanks for the fast response.

Geoff

Yes, confirmed as fixed.

Rgds.

Les.