AnT2nY

Hi, I am doing AVCE ICT and i need to find out how to make a drop down menu. I have already found 2 ways (described below) but i was wondering whether anyone knows how i could use a VBA script to add the data into the drop down menu. Validation Method: enter Jan - Dec in Cells A1-A12 goto Data > Validation > Settings Tab > select Allow List > Click on Source Range And highlight Cells A1-A12 Other Method: View > Toolbars > Forms > Select Combo box and draw it somewhere > right click the drop down menu/combo box > Format Control > Select Input Range (highlight A1-A12 (Jan-Dec)) > click on cell and clikc anywhere on the spreadsheet> and then click ok. However i dont like either of these methods as the data has to be entered onto the sheet. I have sort of found out about the VBA way but getting stuck. Heres how i have kinda done it. View > Toolbars > Control Toolbox > select combo box and draw it > right click the drop down menu and click view source. please can anyone help i have office XP & 2003

Hi, silly question really but my school has symantec web security running and they have stupidly blocked loads of websites is there anyway to enter certain blocked websites? also.. i would like to access my MSN account on msn messenger but obviously it is blocked but i am wondering whether there is a way of getting round this .. i have to connect the th schools network through a proxy so any ideas guys?

thanks very much Nois3 i did look in the HKLM but didnt think to look in the Current User

Ok.. i dont know whether this is in the correct part.. please feel free to move it if it is.. what it is i have win XP SP2 on my laptop and i have a wireless network at my home.. i took my laptop into skool today and found they have a wireless network however i need to enable IEs proxy settings to a ip and a port i got home and i cannot access the internet without going to internet options > connections > LAN Settings > Unchecking the proxy setting box... i was wondering whether there is a reg or bat file that i can make to enable me to click on one of em and either diasble or enable the proxy settings to save me the hassle of opening internet options > connections > LAN Settings > Unchecking the proxy setting box... also i dont really wanna have to restart the laptop after i have done this...

try DEL /f /q "%ALLUSERSPROFILE%\Desktop\*.lnk" DEL /f /q "%USERPROFILE%\Desktop\*.lnk" add /s if you want to delete subdirectories

Whoops i posted this in Part 1 accidently I Dunno Whether this has been posted as it is abig thread ;MSN Messenger: Disables - Auto Busy & Away & Disables the annoying MSN Today On Logon [HKEY_CURRENT_USER\Software\Microsoft\MSNMessenger] "EnableBusyDetect"=dword:00000000 "EnableIdleDetect"=dword:00000000 "AppSettings"=hex:22,02,00,00 Also ... its been posted before but thought i would post it again with some addons of my own... all comments are in order as they go down the list ;Configures Start Menu ;Highlight New Appz - OFF ;Show Help & Support - OFF ;Show My Music - OFF ;Show My Pictures - OFF ;Show Network Connections - Partial (Connect To) ;Show Network Places - ON ;Show Printers - OFF ;Show Search - OFF ;Show Set Program Access & Defaults - OFF ;Show Favourites - OFF ;Group Similar Items - OFF ;Programs On Startmenu1 - 0/OFF ;Hide Inactive Icons - OFF [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced] "Start_NotifyNewApps"=dword:00000000 "Start_ShowHelp"=dword:00000000 "Start_ShowMyMusic"=dword:00000000 "Start_ShowMyPics"=dword:00000000 "Start_ShowNetConn"=dword:00000002 "Start_ShowNetPlaces"=dword:00000001 "Start_ShowPrinters"=dword:00000000 "Start_ShowSearch"=dword:00000000 "Start_ShowSetProgramAccessAndDefaults"=dword:00000000 "StartMenuFavorites"=dword:00000000 "TaskBarGlomming"=dword:00000000 "Start_MinMFU"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer] "EnableAutoTray"=dword:00000000

I Dunno Whether this has been posted as it is abig thread ;MSN Messenger: Disables - Auto Busy & Away & Disables the annoying MSN Today On Logon [HKEY_CURRENT_USER\Software\Microsoft\MSNMessenger] "EnableBusyDetect"=dword:00000000 "EnableIdleDetect"=dword:00000000 "AppSettings"=hex:22,02,00,00 Also ... its been posted before but thought i would post it again with some addons of my own... all comments are in order as they go down the list ;Configures Start Menu ;Highlight New Appz - OFF ;Show Help & Support - OFF ;Show My Music - OFF ;Show My Pictures - OFF ;Show Network Connections - Partial (Connect To) ;Show Network Places - ON ;Show Printers - OFF ;Show Search - OFF ;Show Set Program Access & Defaults - OFF ;Show Favourites - OFF ;Group Similar Items - OFF ;Programs On Startmenu1 - 0/OFF ;Hide Inactive Icons - OFF [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced] "Start_NotifyNewApps"=dword:00000000 "Start_ShowHelp"=dword:00000000 "Start_ShowMyMusic"=dword:00000000 "Start_ShowMyPics"=dword:00000000 "Start_ShowNetConn"=dword:00000002 "Start_ShowNetPlaces"=dword:00000001 "Start_ShowPrinters"=dword:00000000 "Start_ShowSearch"=dword:00000000 "Start_ShowSetProgramAccessAndDefaults"=dword:00000000 "StartMenuFavorites"=dword:00000000 "TaskBarGlomming"=dword:00000000 "Start_MinMFU"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer] "EnableAutoTray"=dword:00000000

Hi, Just Made This Script and all works wicked.. Real.vbs Set WshShell = WScript.CreateObject ("WScript.Shell") WshShell.Run (".\RealPlayer.exe") WScript.Sleep 30000 WshShell.SendKeys "{ENTER}" WScript.Sleep 1000 WshShell.SendKeys "{TAB}" WshShell.SendKeys " " WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{ENTER}" WScript.Sleep 500 WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys " " WshShell.SendKeys "{DOWN}" WshShell.SendKeys " " WshShell.SendKeys "{DOWN}" WshShell.SendKeys " " WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{ENTER}" WScript.Sleep 30000 WshShell.SendKeys "{ENTER}" WScript.Sleep 6000 WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{ENTER}" WScript.Sleep 200 WshShell.SendKeys "{ENTER}" WScript.Quit it also kills the registering process at the end but all you need to do is add the taskkill /f /im realplayer.exe to runcmdex.cmd real.vbs

Yo, I know its a silly question but just wanna try and get it right the first time. Anyone know whether you can copy shortcuts using the runonceex.cmd file. so like i can remove the start menu dir and copy direct links to .exes so it looks better or is there a command to use thru cmd or a reg file? also ... could i just add the .ink files into the C:\XP-CD\$OEM$\$Docs\All Users\Start Menu directory and they will be copied there?